The objective of this analysis is to create a measure of completeness which indicates the access of different blocks in a city to essential points of interest.

Methodology

Here are a list of the five selected amenities, each one’s attributed amenity value, amenity quantity and amenity decay.

amenity amenity_value amenity_quantity amenity_decay
park 0.80 2 0.3465736
supermarket 1.00 4 0.1732868
hospital 0.50 1 0.6931472
school 0.60 6 0.1155245
wastewater_plant 0.05 1 0.6931472

A bit about why we chose each of these amenities:
- Parks are from the entertainment category and have proved to improve the mental and physical health of those around it. By providing green space, people are able to enjoy being outside, exercise and create a social environment which increases happiness levels. Furthermore, having an easy access park increases housing stock around it. Due to the exclusively positive impacts of this amenity, we have given it high value (0.8) however we believe parks are not unique and having too many options will still result in going to the closest one, especially when people have developed a sense of community. As such, we set the amenity quantity at 2.
- Supermarkets provide people with food which is essential but more importantly, healthy foods. Different from convenience stores, they are more accessible and have healthier options. People tend to value having a supermarket close to them as that is a place you have to go to often. This amenity is essential to everyone regardless of race, gender or age and so we decided to attribute maximum value to it. Furthermore, there are many different types of supermarkets and so, having variety adds value however, we believe there is a limit to the number of stores people are willing to go which we believe if close to 4.
- Hospitals are also essential and in the health category. Having a hospital close by is important, especially in emergencies as we know time can save a life. That said, emergencies are rare and on a day-to-day basis, people will more frequently go to clinics. After balancing those factors, we decided to attribute an average value of 0.5 and an amenity quantity of 1 as in an emergency, always go directly and as fast as you can to the closest one to you. In other words, the marginal benefit of having a second hospital is minimal.
- Schools are a part of families’ daily routine and so, being close by adds immense value to both kids and parents. When regarding education, we know people are often willing to go further for better quality if need be. As this amenity does not take quality into consideration, we have assessed its value at 0.6 to account for the very low added benefit a nearby bad school would add. To determine the quantity, we considered that there are three types of schools (primary, middle and upper school) and multiplied that by 2 which we think has a reasonable marginal benefit considering the high variability in quality and other characteristics of schools which lead to individual preferences.
- Wastewater plants are essential towards the functioning of a city however, it is not desirable to be near one. Thus, we have determined its value to be 0.05. That said, there is no marginal benefit to having a second one meaning the amenity quantity is capped at 1.

As for the amenity decay for each of these amenities, we used a logarithmic expression and chose to keep the 0.5 as an intermediate rate.


Next, are the explored modes of transportation (walking, cycling and driving), each of their mode values and mode reasonables.

mode mode_value mode_reasonable mode_decay
walking 1.0 15 0.0462098
cycling 0.8 10 0.0693147
driving 0.3 20 0.0346574

Walking is the most preferred mode and it is ideal to have all amenities within walking distance so is valued at 1.0. This is because it is easily accessible as it does not require any materials, is environmentally friendly and is healthy. That said, it can be tiring especially after 15 minutes which is the mode reasonable value.
Cycling has many of the benefits of walking but requires a bike and its maintenance so is valued at 0.8. Furthermore it is more demanding and so has a lower mode reasonable value of 10.
Driving allows going further but requires dealing with traffic, pollutes and does not provide exercise. This has made it the least preferred mode with 0.3 value. Due to these same reasons mentioned above, it is reasonable to spend more time in this mode and so the chosen mode reasonable was 20.

As for the decay, mode decay follows the exact same equation used for amenity decay.


As a consequence of these choices, the baseline completeness score was 3.90401. This represents the ideal score based on the parameters set above.

Oakland

Here is a map of all Points of Interest in Alameda County:

We can see this is a well developed area with an abundance of resources. It is hard to draw further conclusions from this map due to the large amount of information for a vast area.

More specifically, here is a map showing the distribution of the selected amenities (parks, supermarkets, schools, hospitals and wastewater plants) throughout Alameda County.

We can see the distribution seems fairly equal with centers along the Bay, from Berkeley to Fremont and then Dublin and Livermore.

Before moving on, it is also interesting to see the Oakland’s Census Blocks:


The next major step of this analysis was to generate isochrones. These are essentially filled radii showing how far one could go in a given time period with a given mode of transportation.

In this analysis we have covered 7 combinations: walking in 5, 10 and 15 minutes, cycling in 5, 10 and 15 minutes and driving in 5 minutes. We have purposefully excluded driving in 10 and 15 minutes as that reduces our area of interest and focuses our study strictly to Oakland.

After compiling those and intersecting PoI data with isochrones and our outlined amenity and mode preferences, here is a map showing the completeness score of for each CBG in Oakland.

Overall, there is a ripple effect in which higher completeness scores (lighter colours) are located in the center (excluding the city of Piedmont) which represent easy access to amenities and lower completeness scores (darker colours) are in the fringes of the city, representing the worst access to amenities. Furthermore, when comparing East and West, it can be seen that Western Oakland which is far from the Bay has better scores than Eastern Oakland. This is already surprising as cities are often more developed along their coastlines (althought this is not a coast).

This circular pattern makes sense because isochrones are concentric circles so the areas with best access would be downtown/central Oakland. Perhaps because we limited driving to only 5 minutes (as a reflection of the high friction and annoyance of getting into a car) also could have led to the fringes having worse access. Lakeside park (as seen in our amenity map above) is one of the bigger parks in the city and is located in the center. However, the majority of large parks are on the fringes and a few smaller parklets within the city center. Highland Hospital, Alta Bates Summit Medical Center, and Oakland Medical Center, and the Children’s Hospital are all within the North-Central part of Oakland which also explains the more yellow tones in the region.
Hospitals, supermarkets, and schools tend to be clustered in the densest parts of cities so again it makes sense that there is more access in central Oakland. Wastewater facilities and parks are usually on the less dense parts of cities as they require more space and in Oakland, those happen to be the fringes of the city.

Oakland Income Equity Analysis

Question—Even in a big city like Oakland, would income level determine access to certain amenities? Is there a relationship with income and access in a big urban center? By looking at access to parks, which are seen as a luxury, we can see the correlation bewteen income and park access.

Below is a Map of Isochrones showing a 10 min walking distance radius from every Park in Oakland

It is very interesting to see that there is a large concentration of parks in the North East near the Bay compared to the South-East and South-West inland. Next we will look at the income breakdown of Oakland.

This equity analysis is at the block group level to have the most updated income data (blocks we could only use decennial data) and is based on the assumption that neighborhoods (made up of block groups) most likely have similar income characteristics because of historic patterns of credit lending and redlining.

## 0.7318223 [1]

This 0.7318 output means approximately 73.18% of people are within 10 minutes of a park. This is pretty amazing access and a surprising finding.

Next, let’s take a look at the income distribution across the general population and the population within a 10 min. walk of a park. This result is incredibly fascinating. It is pretty reflective of the income breakdowns of the full population. This means access is performing on par with population income statistics. I have never seen anything like this however, it is highly credible as a significant percentage (73.2%) of the general population is represented in the second group. Thus, not that many people were excluded which explains the small difference.

The largest percentage of the population wihtin a 10 minute walk of a park is the population with the lowest income. Our hypothesis that it is difficult to afford to live near a park is clearly incorrect. Perhaps we would have had a different result if we had lowered our isochrone to just 5 minutes, or even less (meaning they live on the border of the park). Perhaps some reasons this may be the result is that because Oakland is less dense then other similar mid-sized cities, there is naturally occurring open green space more abundantly available. Overall, this is a pretty equitable breakdown of park access.

Palo Alto


In order to draw more accurate conclusions, it is always interesting to make comparisons. Here is the same analysis but for another location - Palo Alto in Santa Clara County, just across the bridge from Oakland, Alameda. To keep this a fair comparison, I have kept the same selected points of interesting, amenity preferences, modes of transport and mode preferences. This results in the same baseline completeness score of 3.90401.

Once again, here is a map for all points of interest all throughout the selected county.

We can see this is an area with a concentration of resources, compared to Oakland, clearly indicating an urban setting. To draw more insightful conclusions, let’s zoom in a bit.
Next is the same map but filtered for our selected points of interest.

We can see the distribution seems fairly equal with centers along the Bay, from Palo Alto to San Jose and then Morgan Hill and Gilroy further South.

As seen with Oakland, here is a map of the Census Blocks for Palo Alto, before layering on any analysis.

Moving onto isochrones, I have generated the same 7 isochrones for each block in Palo Alto: walking (5/10/15), cycling (5/10/15) and driving (5) for the sake of a fair comparison, and applied the same processes to the data.

Finally, here is the complete Palo Alto map with the finalized amenity score for each block. It is clear that anything above Bayshore Fwy and below Juniper Serra Fwy (the two extensions) are the areas with the lowest scores. Within central Palo Alto we can notice a similar pattern to the one in Oakland. The majority of Yellow areas as concentrated in the center, with the same previously described ripple effects with lower scores (not as low as the extremities) located in the fringes of the city. We can also see that to the Left/North of Oregon Expy, the colours are lighter compared to the West/South, indicating better access to the selected amenities.

Palo Alto Income Equity Analysis


Question—In a city known for being wealthy and high-end, will income level determine access to certain amenities or will Oakland’s pattern be followed? Palo Alto is a smaller city than Oakland, will that have an impact by concentrating amenities and thus making them more shared and accessible?

To begin, this is the map of isochrones showing a 10 min walking distance from each Park in Palo Alto

It is very interesting to see that parks are quite evenly distributed but tend to be in areas further away from the bay. Furthermore, there is a larger concentration around Stanford University’s campus and in Charleston Meadows/Castry City. Compared to Oakland, the concentration of park is much lower. Next we will look at the income breakdown of Palo Alto.

Similar to Oakland, this equity analysis is at the block group level to have the most updated income data (blocks we could only use decennial data) and is based on the assumption that neighborhoods (made up of block groups) most likely have similar income characteristics because of historic patterns of credit lending and redlining.



## 0.07507223 [1]

The output is 0.07507 which means there are approximately 7.51% of people are within 10 minutes of a park. This is significantly lower than Oakland and represents very limited access. One possible reason may be that because the city is smaller and less urban (more like a suburb) which means park might not be as essential due to other sources for green space. As a wealthy city, I expect more Palo Alto residents to also have private backyards, making parks less meaningful and thus, less frequent. This could explain why such a small percentage of the population is within a 10 minute walk from a park.

Next, let’s see if there is a difference in income distribution in the population within a 10 min walk of a park compared to the entire population. Given Oakland’s results, I also expect there to be a minimal difference here, despite the lower access.

While the largest percentage of the population wihtin a 10 minute walk of a park is the population with the highest income, the differences are quite small, as predicted. Once again, the hypothesis that it is difficult to afford to live near a park is clearly incorrect. Overall, this is also a pretty equitable breakdown of park access. Another point to be made here is that when looking at the amenity map, we can see that there are parks both in the center and fringes of both cities which means access to them may be more democratic than other amenities.

Concluding Thoughts

Comparing Oakland and Palo Alto I expected to see a much larger difference than was found. Both cities followed the ripple effect with higher completeness scores in the center (better access) and lower scores towards the edges. Another point to consider is that the edge of the cities might be disproportionately disadvantaged in this analysis as we are not considering the amenities which they have access to, and maybe even closer, which are in the neighbor city. This is common and could be explore but eventually, you have to draw a line. The only case where this does not apply is the waterfront line.

In terms of equity distributions, I was extremely surprised with results for both cities. As a potential next step, it would be interesting to create the same income equity analysis but with other amenities to see which amenity has the highest influence. Furthermore, if developed a lot more, tools like these could be used to understand real estate prices and even predict future trends which is quite powerful.